Filter limitations
When creating a filter, the following limitations apply:
- Filters are not supported for calculating columns of Right-to-Left languages.
- Filters can only be applied to immutable columns.
-
Filters on mutable columns:
When a filter is created to exclude/include specific rows in a column, the specified rows will always be excluded/included, even if the rows that were originally excluded/included are later changed. For example, if you chose to exclude/include rows "1-10" in a column named "Age" and those rows were later changed to "11-20", the rows will continue to be excluded/included, even though the data is no longer the same.
Additionally, if a row outside the filter scope was changed (i.e. updated or updated and then deleted) so that it should now be excluded/included (as defined by the filter), it will not be replicated to the target. So, for example if you created a filter to exclude/include rows less than 5 and then changed row 6 to -6, it will not be replicated (even though it is included in the filter's criteria range).
- Filter cannot be applied to LOB columns.
-
When specifying numeric data as a filtering condition, the data preceding the decimal point cannot exceed int64.